2014-10-24 - 15314.100 - Enhancement - Change to navigational manager field #CrystalReportsSupport
ENHANCEMENT
15314.100 - Change to navagational manager field
Requirement Summary
Need to replace the Sales Manager to navigational instead of transactional in the followign reports:
- OSA111
- OSA173
- OSA176
- SA121
- SA161
- SH101
Admin Info
Purpose
|
Need to replace the navigational manager field on the required reports.
|
Requested By
|
Jason Rogers
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
10/24/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
OSA111, OSA173, OSA176, SA161, SH101 & SA121.
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
08
|
3
|
Development/Config
|
16
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
04
|
6
|
Transports
|
08
|
|
TOTAL
|
40
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
10-24-2014 - Email from Mark Grzechowiak - NEC requested us to work on the following requirement:
On the below reports, where we had switched from transactional to navigational sales rep, we need to make the same change to manager. Please let us know what the level of effort for this change will be and when you believe you will be able to complete the work. This project is secondary to other projects currently being worked out including regional/time zone reporting and the work being done for Japan reports.
-OSA111
-OSA173
-OSA176
-SA121
-SA161
-SH101
BW BEx Queries:
Need to add the navigational sales manager in the BEx queries of above reports in BPD(BW 7.3 Development) and create transport requests.
In Scope:
Modify BEx queries to add navigational sales manager field.
Out of Scope:
SH101
Solution Summary
1. Need to add the Sales Manager field navigational in the BEx queries of the reports OSA111, OSA173, OSA176, SA121, SA161 and SH101.
2. Need to create an open transport request & collect all the required changes into this transport request.
3. Need to check if the BEx queries meet the NEC Standards.
4. Need to replace the Navigational Manager field instead of the transactional in the above reports.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
1. Need to add the Sales Manager field navigational in the BEx queries of the reports OSA111, OSA173, OSA176, SA121, SA161 and SH101.
2. Need to create an open transport request & collect all the required changes into this transport request.
3. Need to check if the BEx queries meet the NEC Standards.
4. Need to replace the Navigational Manager field instead of the transactional in the above reports.
5. Need to update sources in the above reports after add the navigational sales manager into the sources.
6. Need to check & follow NEC standards while modifying the reports.
Issues
In SH101 report BEx query, navigational attribute for Sales Manager field is not available since it is not active in the Shipped Infocube.